Spreadsheet Software

The BCS - Spreadsheet Software tutorial takes you through tasks in Excel 2010 as per Module 4 of the ECDL Syllabus 5.

Starting Excel and Help

Upon successful completion you will be able to:

1. Identify the Function of Excel;
2. Start Excel;
3. Use Offline help;
4. Use Help Tools;
5. Use the Search Field;
6. Open the Table of Contents;
7. Use Online Help;
8. Close Excel.

Creating Workbooks

Upon successful completion you will be able to:

1. Create New Workbooks;
2. Input Values, Labels and Dates;
3. Enter Data into a Range;
4. Replace Cell Content;
5. Add Additional Cell Content;
6. Remove Cell Content.

Selection Techniques

Upon successful completion you will be able to:

1. Select a Single Cell;
2. Select a Range of Cells;
3. Select Columns;
4. Select Rows;
5. De-select Cells;
6. Select Data Ranges;
7. Select the Entire Worksheet.

Formulas and Referencing

Upon successful completion you will be able to:

1. Identify Formula Operators;
2. Enter Formulas;
3. Copy Formulas;
4. Use the AutoFill Feature;
5. Update Formula Results;
6. Work with Absolute References;
7. Apply Percentage Values.

Formatting Cells

Upon successful completion you will be able to:

1. Change Numeric Formatting;
2. Modify Fonts and Sizes;
3. Centre Text Across Columns;
4. Align Data in Cells;
5. Wrap Cell Text;
6. Add Borders;
7. Apply Text Attributes;
8. Change Background Colours;
9. Use Format Painter;
10. Change Date Formatting;
11. Clear Formatting.

Creating and Modifying Charts

Upon successful completion you will be able to:

1. Identify the Functions of a Chart;
2. Create Simple Charts;
3. Add Titles and Labels;
4. Re-size Charts;
5. Move and Copy Charts;
6. Change Chart Types;
7. Select Chart Objects;
8. Edit Charts;
9. Create Pie Charts.

Proofing Tools

Upon successful completion you will be able to:

1. Use the Excel Error Checking Feature;
2. Spell Check Worksheets;
3. Enter Data using AutoComplete;
4. Use AutoCorrect;
5. Work with AutoCalculate.

Screen Components

Upon successful completion you will be able to:

1. Identify the Title Bar;
2. Open Backstage View;
3. Display and Hide the Ribbon;
4. Display Screentips for Buttons;
5. Use the Quick Access Toolbar;
6. Identify Worksheet Components;
7. Use the Formula Bar;
8. Recognise Mouse Cursor Shapes.

Opening, Saving and Closing

Upon successful completion you will be able to:

1. Open Excel Workbooks;
2. Open Recently Used Workbooks;
3. Move Between Workbooks;
4. Find Files Using Windows Search;
5. Convert File Formats;
6. Save Workbooks;
7. Use the Save As Command;
8. Close Workbooks;
9. Quit Excel.

Moving and Copying Data

Upon successful completion you will be able to:

1. Differentiate Cut and Copy;
2. Move Data in Worksheets;
3. Move Data Between Worksheets;
4. Move Data Between Workbooks;
5. Use the Paste Options Smart Tag;
6. Copy Data in Worksheets;
7. Copy Data Between Worksheets;
8. Copy Data Between Workbooks;
9. Use the Office Clipboard.

Working with Functions

Upon successful completion you will be able to:

1. Identify Function Components;
2. Enter Functions;
3. Use AutoSum;
4. Use the ROUND Function;
5. Apply the IF Function.

Handling Worksheets

Upon successful completion you will be able to:

1. Delete Worksheets;
2. Insert Worksheets;
3. Move Worksheets;
4. Duplicate Worksheets;
5. Name Worksheet Tabs;
6. Apply Colours to Worksheet Tabs.

Working with Chart Objects

Upon successful completion you will be able to:

1. Format Chart Objects;
2. Select Individual Markers;
3. Change Marker Colours;
4. Change the Background in Charts;
5. Add Data Labels to Markers;
6. Remove Chart Objects;
7. Display, Hide and Move the Legend;
8. Display and Hide Gridlines.

Headers, Previewing and Page Setup

Upon successful completion you will be able to:

1. Use Built-in Headers and Footers;
2. Create Custom Headers and Footers;
3. Print Column and Row Titles;
4. Change Page Orientation;
5. Scale Worksheets for Printing;
6. Use Print Preview;
7. Print Gridlines on Worksheets;
8. Adjust Page Margins;
9. Centre Worksheets on the Page.

Navigating Workbooks

Upon successful completion you will be able to:

1. Scroll through Worksheets;
2. Move around Worksheets;
3. Use the Go To Command;
4. Navigate using the Name Box;
5. Work with Sheet Tabs;
6. Use Tab Scrolling Buttons.

Adding and Removing Cells

Upon successful completion you will be able to:

1. Insert Columns and Rows;
2. Delete Columns and Rows;
3. Insert Cells;
4. Delete Cells;
5. Adjust Column Widths;
6. Change Row Heights;
7. Use Undo;
8. Use Redo;
9. Delete Cell Content.

Printing Worksheets

Upon successful completion you will be able to:

1. Print Worksheets;
2. Set Print Areas in Worksheets;
3. Print Charts;
4. Apply Print Options;
5. Select Printers;
6. Change Printer Properties.

Splitting, Freezing and Options

Upon successful completion you will be able to:

1. Use the Zoom Feature;
2. Split Windows;
3. Freeze Panes;
4. Unfreeze Panes;
5. Customise Excel Settings;
6. Use Save Options;
7. Use Spelling Options;
8. Use Advanced Options.

Searching and Sorting

Upon successful completion you will be able to;

1. Use Find and Replace;
2. Search for Words;
3. Identify Search Options;
4. Use Find Next;
5. Replace Single Occurrences of Text;
6. Use Replace All;
7. Sort Data in Single Columns.

This course can be purchased either individaully or as part of a package.
Single Training Course - Spreadsheet Software :
Office Suite Training Courses - BCS ECDL - Office 2010 (United Kingdom) :